WorksheetsIntroduction to Excel
Total questions: 60
Worksheet time: 30mins
What is MS Excel
A word processor
A spreadsheet program
A database management system
A web browser
Which file extension is used by default for Excel workbooks?
.csv
.xlsx
.docx
.pptx
What is a cell in Excel?
A type of formula
An individual box in a spreadsheet where data can be entered
A tool for creating graphs
A type of chart
What does a spreadsheet primarily consist of?
Rows and documents
Columns and texts
Rows and columns
Cells and files
Which of the following is NOT a common use of spreadsheets?
Preparing reports for marketing
Writing essays
Personnel management
Payroll and accounting
Which of the following is an example of spreadsheet software?
MS Word
Google Sheets
Adobe Photoshop
Mozilla Firefox
What does the term "cell" refer to in a spreadsheet?
A single box to Enter any data
A group of worksheets
A Box with Black Border
The entire spreadsheet
Where does a row appear in a worksheet?
At the top border
At the left border
At the right border
In the center of the worksheet
Where does a column appear in a worksheet?
At the left border
At the right border
On the top border
In the middle of the worksheet
What does the Name Box in Excel display?
The formula used in the active cell
The value in the active cell
The address or name of the selected cell
The worksheet name
Which key is used to insert a new worksheet in Excel?
Ctrl + N
+ icon at the bottom of the worksheet
Insert key
Shift + Enter
What is a cell address in Excel?
The combination of the column letter and row number
The name of the spreadsheet
The name of the workbook
The name of the user
How is a cell reference written on the same sheet?
=Sheet1!A1
=A1
=B2
=1A
How is a cell reference written for a cell on a different sheet in the same workbook?
=A1
=SHEET2!A1
=Sheet1!B1
=B1
What does the status bar in Excel display?
The name of the workbook
Information about the current status of the worksheet
The formula in the active cell
The date and time
Which of the following options can be displayed on the status bar?
Sum
Count
Average
All of the above
How can you customize the options displayed on the status bar?
By double-clicking the status bar
By right-clicking the status bar and choosing the required options
By pressing F1
By opening the File menu
What is the Ribbon in Excel?
A collection of sheets
A strip of buttons and icons located above the work area
A summary of data
A type of chart
How can you hide the Ribbon in Excel?
By pressing Ctrl + H
By double-clicking the active tab
By right-clicking on the worksheet
By closing the workbook
Which is the default view in MS Excel?
Page Layout
Page Break Preview
Normal View
Custom View
What does the Page Break Preview in Excel show?
The formulas used in the worksheet
The formatting applied to cells
Where the page break will appear when printing
The comments inserted in the worksheet
Which view shows exactly how your printed document will look?
Normal View
Page Layout View
Custom View
Full Screen View
Which option is NOT part of the 'Show' group in Excel?
Ruler
Formula Bar
Gridlines
Page Number
Which option in the Zoom group allows you to adjust the view size without changing the actual size of fonts?
Zoom Slider
Scale to Fit
Font Size
Print Area
What happens when you type a formula without an equals sign (=) in Excel?
The cell displays the formula as text
The cell returns an error
The cell automatically converts the text into a formula
The cell value becomes zero
How do you reference a range of cells from A1 to C3?
=A1
=A1-C3
=A1+C3
=A1 to C3
Which symbol is used to lock a cell reference in a formula?
&
$
#
@
What does the term "active cell" mean in Excel?
The cell that is currently selected
The cell that contains the formula
The first cell in the worksheet
The last cell in the worksheet
Where can you view and edit the content of the active cell?
In the status bar
In the Name Box
In the Formula Bar
In the Title Bar
What is the function of the Formula Bar in Excel?
To display the sheet name
To display the formula used in the active cell
To show the status of the worksheet
To show the cell address
What does the Formula Bar allow you to do?
Enter data and formulas
Change the sheet name
Customize the status bar
Hide the Ribbon
How can you insert a new worksheet in Excel?
By clicking the 'Insert' tab
By clicking the '+' icon at the bottom of the worksheet
By using the 'File' menu
By right-clicking the worksheet tab and selecting 'New'
How do you delete a worksheet in Excel?
Click 'Delete' in the Home tab
Right-click the worksheet tab and select 'Delete'
Press Ctrl + D
Close Excel and the worksheet will be deleted
What does the Name Box display?
The title of the worksheet
The name or address of the currently selected cell
The formula used in the worksheet
The number of worksheets in the workbook
What information can be customized on the status bar?
Cell references
Sheet names
Information such as sum, count, and average
Ribbon settings
Which of the following can be done by right-clicking the status bar?
Customizing what information is displayed
Hiding the status bar
Changing the active worksheet
Inserting a chart
Which of the following views is typically used for editing and entering data?
Normal View
Page Layout View
Page Break Preview
Full-Screen View
What does the Page Layout View help you to see?
The formulas used
The actual print layout of the document
The hidden rows and columns
The cell comments
What is the purpose of the Zoom group in Excel?
To change the font size
To adjust the view size without changing the actual font size
To format the worksheet
To insert images
Which key is used to access the Ribbon commands quickly?
F1
Ctrl
Alt
Shift
Which view shows a blue line indicating where the page breaks are?
Normal View
Page Layout View
Page Break Preview
Full-Screen View
Where is the 'Show' group located in Excel?
Home tab
View tab
Insert tab
Page Layout tab
Which of the following is NOT a feature available in the 'Show' group?
Ruler
Gridlines
Formula Bar
Chart Wizard
What happens if you double-click the active tab on the Ribbon?
The Ribbon is minimized
The Ribbon is closed permanently
The active worksheet is deleted
A new worksheet is created
What can be customized in the Ribbon?
Button size
Commands shown
Worksheet names
Zoom settings
Which feature allows you to repeat specific rows or columns on every printed page?
Print Titles
Print Area
Freeze Panes
Page Break Preview
Which area of Excel displays the constant value or formula used in the active cell?
Status Bar
Formula Bar
Name Box
Title Bar
Which key is used to select the entire worksheet?
Ctrl + A
Shift + A
Alt + A
Ctrl + Shift + A
What is the function of the Normal View in Excel?
To display the worksheet for editing and data entry
To prepare the worksheet for printing
To create charts
To insert images
Where is the Insert Sheet button typically located?
On the Home tab
At the bottom of the worksheet, next to the sheet tabs
On the Insert tab
In the status bar
Which Excel view allows you to see how the document will look when printed?
Page Layout View
Normal View
Page Break Preview
Full-Screen View
Which group in the View tab contains the Zoom Slider?
Show Group
Window Group
Zoom Group
Workbook Views Group
How do you start a formula in Excel?
+
=
-
*
Which of the following is NOT a valid Excel formula?
=A1+A2
=SUM(A1)
=AVERAGE(A1)
=AND(A1)
What feature in Excel automatically fills data in cells based on a pattern?
Autofill
Autocomplete
AutoFormat
AutoSum
Which function is used to find the highest value in a range of cells?
MIN
MAX
AVERAGE
SUM
In Excel, which of the following is a logical function?
SUM
IF
COUNT
VLOOKUP
Which tool can you use to combine text from two or more cells into one cell?
CONCATENATE
JOIN
COMBINE
TEXTJOIN
What happens if you type 'Ctrl + Z' in Excel?
It saves the workbook
It pastes the copied content
It undoes the last action
It opens the Help menu
Which tab in Excel contains the basic commands for formatting text?
Insert
Page Layout
Home
Formulas
