Font size
S
M
L
XL
WorksheetsMicrosoft Excel Quiz 1 Grade 12
Total questions: 21
Worksheet time: 21mins
Name
Class
Date
1.
Which Excel feature allows you to automate calculations based on the contents of cells?
a)
WordArt
b)
Formulas
c)
Transitions
d)
Animations
e)
Clipart
2.
What is a spreadsheet in Microsoft Excel?
a)
A tool for creating animations
b)
A program for web browsing
c)
A text editing tool
d)
A digital canvas for drawing
e)
A grid of rows and columns for organizing and analyzing data
3.
What is Microsoft Excel primarily used for?
a)
Sending Emails
b)
Creating Presentations
c)
Making Calculations and Data Analysis
d)
Editing Images
e)
Playing Games
4.
Which term refers to a single intersection of a row and a column in an Excel worksheet?
a)
Cell
b)
Pixel
c)
File
d)
Slide
e)
Chart
5.
Which area contains the alphabetical letters at the top and the numbers on the left side in an Excel worksheet?
a)
Ribbon
b)
Toolbar
c)
Status bar
d)
Formula bar
e)
Cell Grid
6.
Which Excel feature allows you to visually represent data using graphs and charts?
a)
Slides
b)
Animations
c)
Formulas
d)
Charts
e)
Tempates
7.
How can you adjust the width of a column in Excel?
a)
By changing the font size
b)
By changing the page orientation
c)
By clicking and dragging the column boundary
d)
By changing the color of the column header
e)
By adding a border to the column
8.
What is a cell reference in Excel?
a)
A contact information stored in a worksheet
b)
A hyperlink to an external website
c)
A code that unlocks advanced features
d)
A way to identify a specific cell by its column and row
e)
A special type of formula
9.
Which tab in the Excel ribbon contains options related to formatting and styling?
a)
Home
b)
Insert
c)
Review
d)
File
e)
Data
10.
Which of the following is the correct file extension for a Microsoft Excel file?
a)
.xls
b)
.xlsx
c)
.docx
d)
.excel
e)
.sheet
11.
What is the maximum number of columns in a Microsoft Excel worksheet (version 2007+)?
a)
255
b)
4096
c)
655536
d)
1048576
e)
16386
12.
What is the maximum number of rows in a Microsoft Excel worksheet (version 2003 and below)?
a)
255
b)
65536
c)
16386
d)
1048576
e)
100
13.
Which of the following is NOT the correct way to create a new worksheet in a Microsoft Excel workbook?
a)
Click the "New" button on the Home tab.
b)
Press Ctrl+N.
c)
Right-click the tab of the worksheet you want to duplicate and select "Insert."
d)
Shift+F11
14.
What is a formula in Microsoft Excel?
a)
A formula is a mathematical expression that is used to calculate a value.
b)
A formula is a text string that is used to format a cell.
c)
A formula is a function that is used to perform a specific task.
15.
Which of the following is the correct way to enter the formula for calculating the sum of the values in cells A1 and A2?
a)
=SUM(A1;A2)
b)
=SUM(A1,A2)
c)
=A1+A2
d)
=A1+A2*2
e)
=A1+A2^2
16.
Which of the following is the correct way to enter the formula for calculating the average of the values in cells A1, A2, and A3?
a)
=AVERAGE(A1;A2;A3)
b)
=AVERAGE(A1,A2,A3)
c)
=(A1+A2+A3)/3
d)
=SUM(A1:A3)/3
e)
=SUM(A1,A2,A3)/2
17.
What is the function to calculate the maksimum value of a range
(a)
18.
Which function is used to round a number to a specific number of decimal places in Excel?
(a)
19.
What is the result of the formula: =A1 + B1 * 2 - C1 / 3 ?
a)
The sum of the values in cells A1, B1, and C1
b)
The product of the values in cells A1 and B1, minus the result of dividing C1 by 3
c)
The sum of the values in cells A1 and the product of B1 with 2, minus the result of dividing C1 by 3
d)
The sum of the values in cells A1 and B1, multiplied by 2, and then divided by the value in C1 by 3
e)
The result of dividing the sum of A1 and B1 by 2, and then subtracting the value in C1
20.
What does the Excel function "NOW()" do?
a)
Calculates the difference between two time values
b)
Returns the number of days in a given month
c)
Returns the current date and time
d)
Converts a text date into a serial number
e)
Returns the day of the week for a given date
21.
Which Excel function combines rounding a number down to the nearest integer and truncating the decimal portion?
a)
FLOOR
b)
ROUNDDOWN
c)
INT
d)
ROUND
e)
ROUNDUP
Reset
