Explanation

• The formula bar displays the content of the active cell in MS Excel.
  • The formula bar can be used to edit the content of any cell and can be expanded to show multiple lines for the same formula.

Additional Information 

• The name box in the worksheet displays the address of the selected cell.
• The title bar displays the title of the window and It includes the close, minimize, and maximize buttons.
• An active cell refers to a cell in an Excel spreadsheet that is currently selected by clicking the mouse pointer or keyboard keys.

Explanation

A trackball is a pointing device where the ball is held in place by a socket, allowing users to rotate the ball to move the cursor on the screen.

Unlike a traditional mouse, which moves over a surface, a trackball stays stationary, and the ball's rotation controls the cursor's movement in different directions.

Explanation

 Columns are denoted and identified by a unique alphabetical header letter,

which is located at the top of the worksheet.

*************

VU  FIA SUB INSPECTOR  PAPER 30-1-2021

Explanation

DATE: returns the serial date value for a date

TODAY: returns today's date

NOW: returns the current date and time

TIME: assemble a proper time.

***

RY24012023

Explanation

The term electronic mail has been in use with its modern meaning since 1975

And variations of the shorter E-mail have been in use since 1979

there are two parts of A valid email address.

1. email prefix
2. an email domain, 

In the address example@mail.com,

1. "example" is the email prefix,
2. "mail.com" is the email domain.

Explanation

Explanation

To select multiple slides, press and hold Ctrl

while

you click each slide that you want to move, and then drag them as a group to the new location.

ND27-7-2023

Explanation

Explanation

F11 Creates a chart of the data in the current range in a separate Chart sheet.

Some important shortcuts used in MS Excel

•F1 Opens Excel Help

•F2 Edit contents of an excel

•F3 Paste Named Range or Named List

•F4 Toggles between cell references - Absolute, Relative, and Mixed Reference

•F5 Displays the "Go To" dialog box

•F6 Switch between the panes of an Excel workbook if you have a split window

•F7 Opens the "Spelling" option in Excel using which you can check the spellings in your workbook

•F8 Enables and disables the "Extend Mode" selection in Excel.

•F9 Recalculates the output of all formulas in your Excel workbook.

• F10 Displays the keyboard shortcut for the Excel ribbon also known as Excel tips

• F12 Opens the "Save As" dialog box like the "Alt + F2" keys

Explanation

The Ctrl+D key is used to open the Font dialog box with the focus on the Font combo box.

Ctrl+F12 opens a document in Word. 

The Ctrl+D key is used to open the Font dialog box.

Ctrl + H is used to open the Replace Dialog Box.