Use a graphical user interface gui-based spreadsheet application to create and edit spreadsheets - take the quiz

What is the standard file extension for a spreadsheet created in Microsoft Excel?

.xls

.docx

.pptx

.pdf

Which of the following is NOT a commonly used spreadsheet application?

Microsoft Excel

Google Sheets

Apple Numbers

Adobe Photoshop

What is the function of a cell reference in a spreadsheet?

Which of the following is NOT a valid data type in a spreadsheet?

Which of the following is NOT a valid cell reference format in a spreadsheet?

$B$5

R3C7

AB12

While A1, $B$5, and R3C7 are valid cell reference formats, AB12 does not follow the standard column-letter and row-number format. 7. What is the purpose of conditional formatting in a spreadsheet?

How can you freeze rows or columns in a spreadsheet?

What is the purpose of a formula in a spreadsheet?

Which of the following is NOT a valid function in a spreadsheet?

COUNT

VLOOKUP

How can you sort data in a spreadsheet based on a specific column?

Which of the following is NOT a valid method to protect a spreadsheet from unauthorized changes?

Password protection

Read-only mode

Encryption

Hiding cells

What is the purpose of a pivot table in a spreadsheet?

Which of the following is NOT a valid method to insert a new row or column in a spreadsheet?

Right-clicking and selecting "Insert," B) Using the "Insert" menu option

Pressing Ctrl+I

Dragging and dropping a cell

How can you apply a filter to a range of data in a spreadsheet?

Which of the following is NOT a valid method to format cells in a spreadsheet?

Using the "Format Cells" dialog box

Applying pre-defined cell styles

Right-clicking and selecting formatting options

Shouting at the computer

What is the purpose of a named range in a spreadsheet?

Which of the following is NOT a valid method to print a spreadsheet?

Using the "Print" option from the menu

Pressing Ctrl+P

Sacrificing a goat

Right-clicking and selecting "Print"

How can you merge multiple cells into a single cell in a spreadsheet?

Which of the following is NOT a valid method to copy and paste data in a spreadsheet?

Using the "Copy" and "Paste" options from the menu

Pressing Ctrl+C and Ctrl+V

Telepathically transferring data

Right-clicking and selecting copy/paste options

What is the purpose of a hyperlink in a spreadsheet?

Which of the following is NOT a valid method to undo an action in a spreadsheet?

Using the "Undo" option from the menu

Pressing Ctrl+Z

Sacrificing a chicken

Right-clicking and selecting undo option

What is the purpose of a data validation rule in a spreadsheet?

Which of the following is NOT a valid method to create a formula in a spreadsheet?

Typing the formula directly into a cell

Using the "Insert Formula" option from the menu

Consulting a fortune teller

Starting the formula with an equal sign (=)

How can you adjust the width or height of columns or rows in a spreadsheet?

Which of the following is NOT a valid method to insert a function in a spreadsheet?

Using the "Insert Function" option from the menu

Typing the function directly into a cell

Asking a magic eight ball

Selecting the function from a pre-defined list

What is the purpose of a data table in a spreadsheet?

Which of the following is NOT a valid method to protect a spreadsheet from accidental changes?

Using the "Protect Sheet" option from the menu

Setting a password for sheet protection

Hiring a bodyguard

Locking specific cells or ranges

Which of the following is NOT a valid method to navigate between worksheets in a spreadsheet?

Using the sheet tabs at the bottom of the window

Pressing Ctrl+Tab

Consulting a crystal ball

Using the "Go To" option from the menu

Use a graphical user interface gui-based spreadsheet application to create and edit spreadsheets - take the quiz

More Quizzes