1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Nataly [62]
4 years ago
3

Enter a formula in cell F2 using SUMIFS to calculate the total expense (use the named range Cost) where the value in the Categor

y named range is equal to the text string "Office Expense" and the value in the SubCategory named range is equal to the text string "Parking".
Computers and Technology
1 answer:
Kipish [7]4 years ago
8 0

A formula in cell F2 using SUMIFS to calculate the total expense where the value in the Category named range is equal to the text string "Office Expense" and the value in the SubCategory named range is equal to the text string "Parking"

Explanation:

You typed =SUMIF(Category in cell F2.

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Logical button, clicked the Recently Used button, and clicked the Math & Trig button.

In the Math & Trig menu, you clicked the SUMIFS menu item.

Inside the Function Arguments dialog, you typed Cost in the Sum_range input, pressed the Tab key, typed Category in the Criteria_range1 input, pressed the Tab key, typed Office Expense in the Criteria1 input, pressed the Tab key, typed SubCategory in the Criteria_range2 input, pressed the Tab key, typed Parking in the Criteria2 input, and pressed the Enter key.

You might be interested in
What will be the result from running the following program?
qwelly [4]

Answer:

If this is python

then you will get this from console:

Grades
100
93

82

Total
275

5 0
2 years ago
. What are the typical parts of a Change Request Document?
photoshop1234 [79]

Answer:

 Change request is the type of document which basically contain the adjustment of the system by call and the change request is the essential and important part in the process of change management.

Change request must be declarative as, it state that what should be accomplish, but forget about the change that should be completed. The main elements or parts of the change request are:

  • Customer ID
  • Abstract change
  • The deadline change type

The importance of the change request document is that it is used in various type of SDLC and project management system. It is basically originate from the system request from the users.

3 0
3 years ago
The memory capacity in bits for performing the operation y = f (x) using the table lookup method, where x is an 8-bit number and
Flura [38]

Answer:

The page field is 8-bit wide, then the page size is 256 bytes.

Using the subdivision above, the first level page table points to 1024 2nd  level page tables, each pointing to 256 3rd page tables, each containing 64 pages. The program's address space consists of 1024 pages, thus we need we need 16 third-level page tables. Therefore we need 16 entries in a 2nd level page table, and one entry in the first level page table. Therefore the size is: 1024 entries for the first table, 256 entries for the 2nd level page table, and 16 3rd level page table containing 64 entries each. Assuming 2 bytes per entry, the space required is 1024 * 2 + 256 * 2 (one second-level paget table) + 16 * 64 * 2 (16 third-level page tables) = 4608 bytes.

First, the stack, data and code segments are at addresses that require having 3 page tables entries active in the first level page table. For 64K, you need 256 pages, or 4 third-level page tables. For 600K, you need 2400 pages, or 38 third-level page tables and for 48K you need 192 pages or 3 third-level page tables. Assuming 2 bytes per entry, the space required is 1024 * 2 + 256 * 3 * 2 (3 second-level page tables) + 64 * (38+4+3)* 2 (38 third-level page tables for data segment, 4 for stack and 3 for code segment) = 9344 bytes.

Explanation:

16 E the answer

5 0
3 years ago
The Zoom slider will allow users to _____.
NeX [460]
The Zoom slider will allow users to change the way the document appears on the screen
3 0
3 years ago
Read 2 more answers
A mnemonic is a tool that you can use when you are studying to help you do which of the following?
hichkok12 [17]
The answer is a. A mnemonic is a tool to aid retention
5 0
3 years ago
Read 2 more answers
Other questions:
  • Given that the array monthSales of integers has already been declared and that its elements contain sales data for the 12 months
    6·1 answer
  • This toolbar has icons representing the application's basic operations such as Save and Copy. Drawing Formatting Standard Task
    11·2 answers
  • Write a program that has the following String variables: firstName, middleName, and lastName. Initialize these with your first,
    7·1 answer
  • Write a function strlen_recursive which accepts a pointer to a string and recursively counts the number of characters in the pro
    6·1 answer
  • It is an island country; it fought against us in World War II; it is known for sushi.
    14·2 answers
  • What 2 important components are found on a motherboard? (2 points each)
    13·1 answer
  • Jacob is a website designer. Whenever his company takes on a new project, Jacob takes the initiative and comes up with ideas and
    14·1 answer
  • 71 81 77 15 63 96 36 51 77 18 17
    14·1 answer
  • Overview In this assignment, you will gain more practice with designing a program. Specifically, you will create pseudocode for
    7·1 answer
  • Data becomes _____ when it is presented in a context so that it can answer a question or support decision makin
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!