ICT Review

1.    What is a spreadsheet?

• A computer program used for creating and managing spreadsheets

• A piece of paper used for recording numerical data

• A database management system

• A graphical user interface

What is the default file format for Microsoft Excel?

• .docx 

• .pptx

• .xlsx

• .pdf

1.    Which of the following is NOT a way to reference a cell in a formula?

• A1

• B2

• C3

• 1A

Which of the following is not a valid way to enter data into a cell in a spreadsheet?

• Typing in the data

• Copying and pasting the data

• Dragging and dropping the data

• Using the voice input feature

  What is the name of the area in the Excel window that displays the current zoom level and allows you to adjust it?

• Formula Bar

• Status Bar

• Name Box

• Zoom slider

Which symbol is used to begin a formula in a spreadsheet program?

• %

• &

• @

• =

Which of the following is a tool used to format numbers, currency, and dates in Excel?

• Sort

• Filter

• Conditional Formatting

• Formal Cells

Which of the following is a tool used to add borders, shading, and colors to cells in Excel?

• Sort

• Filter

• Conditional Formatting

• Format cells

Which of the following is a tool used to display data in a chart or graph in Excel?

• Sort

• Filter

• Conditional Formatting

• Charts

You have a table with multiple columns and rows, and you want to highlight the entire row when the value in column A is greater than 50. Which of the following formatting options would you use?

• Conditional Formatting

• Number Format

• Fill Color

• Font