WorksheetsQUIZ 3 (Class 8)
Total questions: 14
Worksheet time: 14mins
Name
Class
Date
1.
What is formula?
a)
A graphical representation of data.
b)
A type of chemical compound.
c)
A set of instructions for cooking.
d)
A mathematical expression representing a relationship between variables.
2.
How to enter formula
a)
Type '+' followed by your formula in the desired cell.
b)
Type '=' followed by your formula in the desired cell.
c)
Enter your formula in the toolbar above.
d)
Use 'set' followed by your formula in the cell.
3.
Move a formula and keep references from changing
a)
Use absolute references (e.g., $A$1) in the formula.
b)
Use relative references (e.g., A1) in the formula.
c)
Apply conditional formatting to the formula.
d)
Copy and paste the formula without adjustments.
4.
Use a table to enter formulas automatically
a)
Use a word processor to create a table and enter formulas manually.
b)
Create a table in a presentation software to input formulas automatically.
c)
Use a database application to generate tables without formulas.
d)
Use spreadsheet software to create a table and drag the fill handle to enter formulas automatically.
5.
Use AutoComplete + tab to enter functions
a)
Use AutoComplete + Enter to enter functions.
b)
Press Tab to complete functions without AutoComplete.
c)
Use AutoComplete + Tab to enter functions.
d)
Use AutoComplete + Shift to enter functions.
6.
Use Paste Special to adjust values in place
a)
Use Paste to overwrite existing values directly.
b)
Select the entire sheet to apply Paste Special.
c)
Use Copy and Paste without any adjustments.
d)
Use Paste Special to adjust values in place by selecting the operation you want after copying the values.
7.
Use named ranges to make formulas more readable
a)
Use named ranges to improve formula readability.
b)
Named ranges are only for data validation.
c)
Avoid using named ranges for clarity.
d)
Use named ranges to complicate formulas.
8.
On excel A,B,C... are?
a)
Row labels in a spreadsheet.
b)
Data types in a database.
c)
File formats for saving documents.
d)
Column headers in a spreadsheet.
9.
On Excel 1,2,3... are?
a)
Rows
b)
Boolean values
c)
Date values
d)
Text values
10.
On Excel for example A7 is?
a)
Cell B7
b)
Cell A7
c)
Column A
d)
Row 7
11.
Logical Operators on Excel?
a)
=, <, >, >=, <=, <>
b)
AVERAGE
c)
SUM
d)
IF
12.
Math operators on Excel?
a)
+ (addition), - (subtraction), * (multiplication), / (division)
b)
& (bitwise AND)
c)
% (modulus)
d)
^ (exponentiation)
13.
What is Excel?
a)
Excel is a graphic design tool.
b)
Excel is a word processing software.
c)
Excel is a spreadsheet program by Microsoft.
d)
Excel is a database management system.
14.
Which apps are similar like Excel?
a)
Google Sheets, LibreOffice Calc, Apple Numbers
b)
Notepad
c)
Adobe Photoshop
d)
Microsoft Word
100 %
