Close Menu
Login
(Sponsored by Sir Tauqeer)
Join Sir Tauqeer Whatsaap group
(Sponsored by Sir Tauqeer)
Join Sir Tauqeer Whatsaap group
(Sponsored by Sir Tauqeer)
Join Sir Tauqeer Whatsaap group
By Computer Mcqs Microsoft Excel Mcqs PAST PAPERS PPSC Canal Patwari Past Papers 2023 MCQs PPSC PAST PAPERS No Comments

Another name for a pre programmed formula in excel is ___________?

A. Cell
B. Graph
C. Function
D. Range

Submitted by: Areesha Khan

Advertisement

A pre-programmed formula in Excel is also called a function.

Functions are predefined formulas that perform calculations using specific values (arguments) in a set order, allowing users to easily perform various operations without having to write complex equations from scratch.

Key points about functions in Excel:

  • Pre-built: They are already available within Excel, ready to be used.
  • Variety of operations: Excel has functions for simple calculations like addition, average, count, as well as more complex operations.
  • Syntax: To use a function, you type its name followed by the required arguments within parentheses, separated by commas.

Related Mcqs:

  1. In Excel which key is used to open the excel formula window?
    A. Shift+F6 B. Shift+F3 C. Alt+Shift+F3 D. Alt+Shift+F6 Submitted by: Muhammad Danish...
  2. In Excel which key is used for create a formula to sum all of the above cells?
    A. Ctrl+= B. Alt+- C. Alt+= D. Ctrl+- Submitted by: Muhammad Danish...
  3. Which of these keys are used in Ms Excel to copy formula from above cell?
    A. Ctrl+ ” B. Ctrl+ ; C. Ctrl+ : D. Ctrl+ ‘ Submitted by: FAWAD MATLOOB...
  4. What is the function of Vlookup formula in Excel ?
    A. VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value. B. VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value. C. VLOOKUP returns a value from the same row as the lookup value,...
  5. The first computers were programmed using___________?
    A. Assembly language B. Machine language C. Source code D. Object code...
  6. What is the other name for programmed chip?
    A. A. RAM B. ROM C. LSIC D. PROM Updated by: Zulqurnain Zeeshan...
  7. After ‘PROM’ is programmed, we can only ____ the information?
    A. Read B. Write C. Read and Write D. Remove Submitted by: Malik Asghar Hussain...
  8. In Ms Excel Ready made templates are available under _______ tab ?
    A. File B. Insert C. Design D. None of Above Submitted by: Ali Mallah...
  9. ________________________ is not a valid data type in excel?
    A. Number B. Label C. Character D. none...
  10. Which shortcut key is used to create chart in MS Excel?
    A. F10 B. F12 C. F11 D. None Submitted by: Areesha Khan...
Advertisement

The correct answer to the question: "Another name for a pre programmed formula in excel is ___________?" is "Function".

Share.
Leave A Reply

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.