What does the Page Layout tab allow you to do?

Adjust page size, margins, and orientation

What does the Ribbon in Excel contain?

Different Excel tabs with tools and commands

In Excel, what is a Workbook?

The entire Excel document that contains multiple sheets

What is the main difference between formulas and functions in Excel?

Formulas are arithmetic operations, functions are pre-defined calculations

studbud

ETECH-QUIZ 5

15 termsStudBud Administration33 plays

Imported from external platform

Flashcards15 cardsFPractice quizPHost liveL

Questions 15

Answers

1
Which part of Excel identifies the currently active cell?
Sheet Tab
Quick Access Toolbar
Status Bar
Name Box
2
What does the Page Layout tab allow you to do?
Format text and numbers
Apply mathematical operations
Adjust page size, margins, and orientation
Sort and filter data
3
Which of the following is a valid cell reference?
5C
B5
10A
C-3
4
Which feature allows you to lock a cell so it cannot be changed?
Data Validation
Protect Sheet
Merge & Center
Conditional Formatting
5
Which tab contains basic formatting options like font and alignment?
Insert
Data
Home
Review
6
Which of the following is NOT a part of an Excel document?
Formula Bar
Status Bar
Start Menu
Quick Access Toolbar
7
What does the Ribbon in Excel contain?
A set of graphs for visualizing data
A collection of formulas
Different Excel tabs with tools and commands
A storage location for Excel files
8
What is the primary function of a spreadsheet application like Microsoft Excel?
Editing videos
Managing and analyzing data
Creating presentations
Writing essays
9
What is the default alignment for numbers in Excel?
Center
Left
Justified
Right
10
How do you select an entire row in Excel?
Click the row number
Click the column letter
Use the Formula Bar
Click any cell in the row
11
Which part of the Excel window allows you to switch between sheets?
Quick Access Toolbar
Status Bar
Sheet Tabs
Formula Bar
12
In Excel, what is a Workbook?
The entire Excel document that contains multiple sheets
A toolbar used for formatting
A template used for creating invoices
A single sheet inside Excel
13
What is the main difference between formulas and functions in Excel?
Formulas require an equal sign, but functions do not
Functions are used for formatting, while formulas perform calculations
Formulas are arithmetic operations, functions are pre-defined calculations
Formulas are used for text formatting, while functions are used for numbers
14
What symbol must be used before entering a formula in Excel?
=
*
#
+
15
What are the small rectangular boxes where data is entered in an Excel sheet called?
Cells
Columns
Rows
Tabs

ETECH-QUIZ 5 Flashcards | StudBud