NEW
Font size
Worksheets6C 1st semester exam
Total questions: 43
Worksheet time: 10hrs 2mins
Which of the following is a valid Excel formula to add the values in cells A1 and B1?
=A1 + B1
A1 + B1
=SUM(A1 B1)
A1 + B1 =
What does the function =SUM(A1:A5) do?
Adds up the values in cells A1 to A5.
Subtracts the values in cells A1 to A5.
.
Multiplies the values in cells A1 to A5.
Divides the values in cells A1 to A5
How do you start a formula in Excel?
Start with a number.
Start with an equals sign (=).
Start with a dollar sign ($).
Start with a plus sign (+).
Which of the following is used to calculate the total of a group of numbers in Excel?
=AVERAGE()
=SUM()
=COUNT()
=MIN()
What is a workbook in Excel?
A single worksheet.
A collection of multiple sheets within a file.
A type of formula.
A chart or graph
What is the cell in the worksheet in which you can type data?
Main cell
absolute cell
active cell
open cell
A column is identified by which of the following?
number
letter
symbol
none of the above
Which of the following is a correct cell reference?
B8
7A
77G
All of the above
The Merge and Center icon will combine the contents of the selected cells into one larger cell.
True
False
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
Cell address
Worksheet
Formula
What is the purpose of the "Autofill" in Excel?
Combines cells and centers the content
Format cells.
Copy or extend a formula or value across a range of cells.
Change the font style of selected cells.
The intersection of a row and a column is called a _____
Row
Column
Cell
Worksheet
What is the second name of Microsoft Excel?
Spreadsheet
Word
Powerpoint
Data
To create darkened, bold grid lines around your cells, what must you select?
All Borders
All Grids
Outer Borders
Bold Grids
Excel allows you to
read stories
work with data
invent ideas
Microsoft Excel allows you to work on multiple sheets at the same time.
False
True
Which statement is true?
Columns are identified by numbers
Columns run from top to bottom
Rows are identified by letters
Rows run from right to left
Define Cell?
The dark bordered box in excel.
A box in Excel that has formulas.
The intersection of a column or row in a worksheet or table.
Fx Bar where you input data.
Which of the following is the correct cell address?
A1
2B
AA11
What is the Sum formula?
Sum( )
Sum( )=
=Sum( )
=( )Sum
Which of the following option is a formula?
A. =SUM(A1:A5)
B. Add A1 - A5
C. Subtract the numbers
D. A1 = A5
Types of data in MS Excel is ........
Numbers, text, formulas
Numbers, letters, alphabets
symbols
None of these
What should be done to close the workbook?
Click on the Save and Close button
Close the workbook
Copy the data
Open a new workbook
What is the purpose of merging cells in Excel?
To split data into multiple cells
To combine multiple cells into one
To delete unnecessary data
To create a new sheet
How can a cell be formatted to display currency in Excel?
Right click and select Currency format
Use the Format Painter tool
Apply the Currency format from the Number group
Copy and paste the currency symbol
A program using a table consisting of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
Use this option to...
Change font color
Underline
Highlight
Change font size
How do you enter the number '10' into a cell in Excel?
Type '10' and press the 'Enter' key
Write '10' on the screen with a stylus
Say 'ten' out loud to the computer
Draw the number '10' on a piece of paper and scan it
What do you click on to change the background color of a cell in Excel?
The 'File' menu
The 'Home' tab and then the 'Fill Color' button
The 'Insert' tab
The 'Data' tab
How do you make the text in a cell bold in Excel?
Yell the text loudly when typing
Click on the 'B' button in the 'Home' tab
Shake the computer
Use a bold marker to write on the monitor
What is the function of the mouse pointer in the image?
It allows you to move the contents of the cell
It allows you to select more than one cell
It copies what is in the cell
It allows you to widen the column
What is the function of the mouse pointer in the image?
It allows you to move the contents of the cell
It copies what is in the cell
It allows you to select more than one cell
It allows you to widen the column
What is the function of the mouse pointer in the image?
It allows you to select more than one cell
It copies what is in the cell
It allows you to widen the column
It allows you to move the contents of a cell
What is the function of the mouse pointer in the image?
It allows you to select more than one cell
It copies what is in the cell
It allows you to widen columns
It allows you to move the contents of a cell
This is the name of the cell in the worksheet that is currently selected.
Active cell
Highlighted cell
Formula cell
Inactive cell
What is the function of the mouse pointer in the image?
It selects the entire column
It selects the entire row
It moves the entire column
it moves the entire row
It is impossible to add borders in Excel.
True
False
