Font size
WorksheetsMicrosoft Excel Worksheet with Answers - ICT
Total questions: 34
Worksheet time: 17mins
Which option is used to hide a column in Excel?
Right-click → Hide
Delete
Clear
Remove
Which option allows you to unhide rows?
Format → Hide
Format → Unhide
Insert → Row
View → Show
Which feature is used to rotate text in Excel cells?
Text Wrap
Text Orientation
Merge Cells
Alignment
Which function returns the current date?
NOW()
TODAY()
DATE()
DAY()
Which function extracts the day number from a date?
(a)
Which function extracts the month from a date?
DAY()
MONTH()
YEAR()
NOW()
Which function extracts the year from a date?
YEAR()
MONTH()
DAY()
DATE()
What is the maximum number of rows in Excel 2016?
65536
1048576
16384
1000000
What is the maximum number of columns in Excel 2016?
65536
256
16384
1000
Which shortcut key is used to hide a column?
Ctrl + 9
Ctrl + 0
Ctrl + H
Which shortcut key is used to hide a row?
Ctrl + 9
Ctrl + 0
Ctrl + R
Ctrl + Shift + 9
Where can you find the 'Orientation' option?
Insert Tab
Data Tab
Home Tab
View Tab
Which function gives the serial number of the current date and time?
NOW()
DATE()
DAY()
TODAY()
Which feature adjusts the direction of text horizontally or vertically?
Text Orientation
Wrap Text
Merge & Center
Format Painter
In Excel 2016, the last column is labeled as:
ZZZ
IV
XFD
AAA
Part B: Fill in the Blanks 1. The shortcut to hide rows in Excel is _________.
Ctrl + 9
Ctrl + 0
Ctrl + Shift + 9
Alt + H + O + U
The shortcut to hide columns in Excel is _________.
Ctrl + 0
Ctrl + 9
Ctrl + Shift + 0
Alt + H + O + U
Part B: Fill in the Blanks 3. The function _________ returns the current date in Excel.
TODAY()
NOW()
DATE()
CURRENTDATE()
The maximum number of rows in Excel 2016 is _________.
1048576
65536
1000000
16384
The maximum number of columns in Excel 2016 is _________.
16384
1048576
256
65536
Part C: Match the Following Match the functions with their descriptions: 1. TODAY() ->
A. Returns current date
B. Extracts day from a date
C. Extracts month from a date
D. Extracts year from a date
E. Returns current date and time
Part C: Match the Following Match the functions with their descriptions: 2. DAY() ->
A. Returns current date
B. Extracts day from a date
C. Extracts month from a date
D. Extracts year from a date
E. Returns current date and time
Part C: Match the Following Match the functions with their descriptions: 3. MONTH() ->
A. Returns current date
B. Extracts day from a date
C. Extracts month from a date
D. Extracts year from a date
E. Returns current date and time
Match the functions with their descriptions: 4. YEAR() ->
Returns current date
Extracts day from a date
Extracts month from a date
Extracts year from a date
Returns current date and time
Match the functions with their descriptions: 5. NOW() ->
Returns current date
Extracts day from a date
Extracts month from a date
Extracts year from a date
Returns current date and time
Hiding and unhiding rows and columns in Excel can be done by which of the following methods?
By right-clicking the row or column header and selecting Hide or Unhide
By double-clicking any cell in the worksheet
By pressing Ctrl+Alt+Delete
By using the Save As option
Text orientation in Excel refers to the direction in which text is displayed in a cell. Which of the following are examples of its use?
Rotating text vertically and angling text diagonally
Changing font color and increasing font size
Merging cells and adding borders
Inserting charts and creating formulas
Which of the following correctly differentiates between the TODAY() and NOW() functions with examples?
TODAY() returns the current date, while NOW() returns the current date and time. For example, TODAY() might return 2024-06-10, while NOW() might return 2024-06-10 14:30:00.
TODAY() returns the current time, while NOW() returns only the current date.
TODAY() and NOW() both return only the current date.
TODAY() returns yesterday's date, while NOW() returns tomorrow's date.
The maximum number of rows and columns available in Excel 2016 are important because they determine the amount of data you can store. What are these maximum values?
1,048,576 rows and 16,384 columns
65,536 rows and 256 columns
500,000 rows and 10,000 columns
2,000,000 rows and 20,000 columns
The DAY(), MONTH(), and YEAR() functions are useful in analyzing date data because they allow you to extract specific parts of a date. Which of the following best describes their use?
They extract the day, month, and year from a date, allowing for detailed analysis of date data.
They convert text to numbers for easier calculations.
They sort data alphabetically by month names.
They combine multiple dates into a single value.
Use the above table to calculate the SUM of values for Employee A for Jan, Feb, and Mar. What is the total?
4500
4200
3900
4800
Use the above table to calculate the AVERAGE of values for Employee B for Jan, Feb, and Mar. What is the average?
1100
1000
1200
900
According to the above table, what is the MINIMUM value recorded for Employee C in Jan, Feb, or Mar?
900
950
1000
1100
According to the above table, what is the MAXIMUM value recorded for Employee E in Jan, Feb, or Mar?
1700
1200
1500
1600
