Quiz on Electronic Spreadsheet (Advanced)

What does Data Consolidation allow you to do?

• Delete unnecessary data

• Gather data from separate worksheets into a master worksheet

• Format cells in a worksheet

• Create charts from data

Which function is used to add subtotals in a spreadsheet?

• SUBTOTAL

• COUNT

• AVERAGE

• SUM

What is the purpose of Scenarios in a spreadsheet?

• To test 'what-if' questions

• To create charts

• To format cells

• To delete data

What does the Goal Seek function do?

• It finds the value needed to achieve a specific result

• It creates charts from data

• It formats cells in a worksheet

• It deletes unnecessary data

What is the main difference between Goal Seek and Solver?

• Solver deals with multiple unknown variables

• Goal Seek is used for formatting

• Solver is used for creating charts

• Goal Seek can only handle one variable

How can you insert a new sheet in a spreadsheet?

• By selecting the plus icon at the bottom of the screen

• By deleting an existing sheet

• By closing the spreadsheet

• By renaming an existing sheet

What is a cell reference?

• A function to create charts

• A method to delete data

• A tool for formatting cells

• A way to refer to a cell or range of cells

What is the purpose of hyperlinks in a spreadsheet?

• To format cells

• To create charts

• To delete unnecessary data

• To jump to different locations or files

What feature allows multiple users to work on a spreadsheet simultaneously?

• Formatting cells

• Sharing the workbook

• Deleting data

• Creating charts

What is a macro in a spreadsheet?

• A saved sequence of commands or keystrokes

• A function to create charts

• A method to delete data

• A tool for formatting cells