i 模試　Excel関数

"Excel functions"

I have described in the test format, how to use.
Point Taming Excel is "function". However, there is a function of more than 300 in Excel, to fully master it is very. So this project were selected function practical, combined with the right stuff in the right place in the example, it is a thing aimed at up work efficiency.

And logic function
(IF function, AND function, OR function, NOT function, FALSE function, TRUE function, IFERROR function)

· String Functions
(ASC function, JIS function, LEFT function, LEFTB function, RIGHT function, RIGHTB function, LEN function, LENB function, CONCATENATE function, LOWER function, UPPER function, PROPER function, PHONETIC function, CLEAN function, TRIM function, FIND function, FINDB function, MID function, MIDB function, SEARCH function, SEARCHB function, REPLACE function, REPLACEB function, SUBSTITUTE function, REPT function, VALUE function)

, Search, and matrix functions
(COLUMN function, ROW function, VLOOKUP function, HLOOKUP function, LOOKUP function, CHOOSE function, INDEX function, MATCH function, OFFSET function)

, Date and time functions
(TODAY function, NOW function, YEAR function, MONTH function, DAY function, TIME function, HOUR function, MINUTE function, SECOND function, DATE function, DAY function, DAYS360 function, WEEKDAY function, NETWORKDAYS function, DATEDIF function)

And financial functions
(FV function, PMT function, PV function, RATE function, IPMT function, PPMT function, DB function, SLN function, SYD function, NPV function, XNPV function, NPER function, IRR function, XIRR function, NOMINAL function)

Database function
(DSUM function, DAVERAGE function, DCOUNT function, DCOUNTA function, DMAX function, DMIN function, DPRODUCT function)

Problems were divided into six categories Excel functions that are commonly used, Remarks configuration, I'm out in the quiz format things that combines function of the theme of familiar examples by category each function.

Skill check my course, I can be a better understanding of on a daily basis.

In addition, I think has been renewed "if i", by simply touching the screen basically, if it is possible to touch sensuously-intuitively not have to think too hard, to be able to operate as intended. It is not difficult if you know the operation of basic smartphone.

First of all, please try to actually touch.

Feeling as if reading a book of lifelike.
Sense to run a marker pen reference books.

You think you can accept anyone quite naturally.

Was the feature of "if i" and "marker pen function", it becomes able to play smoother, awkwardness of Android has been resolved.

■ How to use
Title screen
• From the Following: Keep selection of answers so far
- From the beginning: to the category selection mode
• Setting: various settings
- Erases all of the marker

Problem, answer selection screen
• The left and right slide: before issue, to the next problem (swipe function)
Touch the frame of choice: previous problems with touch left edge, at the right touch to the next problem (touch function)
· ▽ △ button: problem, enlarged display of the answer choices
· The number buttons: answer choices display
-To answer: answer, to display commentary (number button selection required)
Page number: slider displayed on tap
- Free movement to any page from the title screen with the slider
Slider erased by tapping the screen

Answer, commentary display screen
Scroll mode (in the upper right ↑ display)
• The slide up and down: scroll display
Pen button: Switch to the marker function
· (Eraser or pen display in the upper-right corner) marker mode
Scroll button: Switch to the scroll function
Pen button: marker color selection, marker mode
- Eraser button: erase marker mode
• Select the marker to be erased by the tap (display dark color)
And erase tap again
Undo button: erase marker that is drawn just before