Review Quin in ICT 10

Microsoft Excel is primarily used for:

• Composing and editing music

• Editing videos and animations

• Designing graphics and visual effects

• Managing and analyzing data using spreadsheets

Which part of the Excel interface allows users to enter and edit data in a selected cell?

• Formula Bar

• Status Bar

• Ribbon

• Task Pane

In Excel, a file is referred to as a:

• Database

• Folder

• Document

• Workbook

What is the function of the Ribbon in Microsoft Excel?

• Displays recently saved documents

• Shows the active worksheet's title

• Provides tools and commands organized in tabs

• Stores all created Excel files

Which term describes the intersection of a row and a column in an Excel spreadsheet?

• Cell

• Sheet

• Formula

• Table

What happens if you enter "=SUM(A1:A5)" in a cell?

• It calculates the total of values in A1 to A5

• It divides the values in A1 to A5

• It deletes the values in A1 to A5

• It multiplies the values in A1 to A5

Which shortcut key is used to quickly save an Excel workbook?

• Ctrl + C

• Ctrl + S

• Ctrl + P

• Ctrl + Z

How does a spreadsheet differ from a word processing document?

• Spreadsheets are only used for designing presentations

• Spreadsheets are used only for programming, while word processors are for calculations

• Spreadsheets cannot store data, unlike word processors

• Spreadsheets organize and analyze numerical data, while word processors focus on text formatting

Why is it important to format cells in an Excel worksheet?

• To automatically print the document in a specific format

• To change the color of the worksheet for aesthetic purposes

• To improve the readability and organization of data

• To prevent Excel from performing calculations

A company needs to calculate the average sales of its products over six months. Which Excel function should they use?

• =AVERAGE()

• =IF()

• =COUNT()

• =SUM()